IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[csp_GetSponsorNameInfoEd]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[csp_GetSponsorNameInfoEd]
GO

--  csp_GetSponsorName 9363
CREATE PROCEDURE [dbo].[csp_GetSponsorNameInfoEd]      
(      
	@sponsorId int   
)        
AS        
BEGIN    

	select distinct Name as SponsorName
	from INSIGHT_RPT_DB.dbo.AdmSponsor 
	where InfoEdSponCode  = @sponsorId

END

GO

